using System;
using System.Data;
using System.Data.SqlClient;

public class <Database>DataClass
{
    public static SqlConnection GetConnection()
    {
        string connectionString
             = "<CSConnectionString>";
        SqlConnection connection = new SqlConnection(connectionString);
        return connection;
    }
}

public class <OwnerU>_<TableU>DataClass
{
    public static <OwnerU>_<TableU>Class Select_Record(<OwnerU>_<TableU>Class cls<OwnerU>_<TableU>Para)
    {
        <OwnerU>_<TableU>Class cls<OwnerU>_<TableU> = new <OwnerU>_<TableU>Class();
        SqlConnection connection = <Database>DataClass.GetConnection();
        string selectStatement
            = "SELECT " 
            <Loop>
            + "    <SF[,]>[<Field>] "
            </Loop>
            + "FROM "
            + "     [<Owner>].[<Table>] "
            + "WHERE "
            <If Loop>
               <IsPKey>
            + " <SF[AND ]>[<Field>] = @<Field> "
            </If Loop>
            <If Loop>
               <IsNotPKey>
               <And>
               <IsIdentity>
            + "    [<Field>] = @<Field> "
            </If Loop>
            <If Loop>
               <IsNotIdentityCount>
               <And>
               <IsNotPKeyCount>
   	       <And>
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
            + "    [<Field>] = @<Field> "
               <ExitLoop>            
            </If Loop>
            + "";
        SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
        selectCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsPKey>
        selectCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>Para.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotPKey>
           <And>
           <IsIdentity>
        selectCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>Para.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
   	   <And>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
        selectCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>Para.<FieldU>);
           <ExitLoop>
        </If Loop>
        try
        {
            connection.Open();
            SqlDataReader reader
                = selectCommand.ExecuteReader(CommandBehavior.SingleRow);
            if (reader.Read())
            {
                <If Loop>
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsFloat>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (Decimal?)(Double?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsReal>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (Decimal?)(Single?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsNotFloat>
                    <And>
                    <IsNotReal>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (<VBType>?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNotNullable>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : reader["<Field>"].ToString();
                    <IsNotNull>
                cls<OwnerU>_<TableU>.<FieldU> = <Convert>(reader["<Field>"]);
                </If Loop>
            }
            else
            {
                cls<OwnerU>_<TableU> = null;
            }
            reader.Close();
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
        return cls<OwnerU>_<TableU>;
    }

    public static bool Add(<OwnerU>_<TableU>Class cls<OwnerU>_<TableU>)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string insertStatement
            = "INSERT " 
            + "     [<Owner>].[<Table>] "
            + "     ( "
            <If Loop>
               <IsNotIdentity>
            + "    <SF[,]>[<Field>] "
            </If Loop>
            + "     ) "
            + "VALUES " 
            + "     ( "
            <If Loop>
               <IsNotIdentity>
            + "    <SF[,]>@<Field> "
            </If Loop>
            + "     ) "
            + "";
        SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
        insertCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (cls<OwnerU>_<TableU>.<FieldU>.HasValue == true) {
            insertCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            insertCommand.Parameters.AddWithValue("@<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (cls<OwnerU>_<TableU>.<FieldU> != null) {
            insertCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            insertCommand.Parameters.AddWithValue("@<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNotNull>
        insertCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        </If Loop>
        try
        {
            connection.Open();
            int count = insertCommand.ExecuteNonQuery();
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
    }

    public static bool Update(<OwnerU>_<TableU>Class old<OwnerU>_<TableU>Class, 
           <OwnerU>_<TableU>Class new<OwnerU>_<TableU>Class)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string updateStatement
            = "UPDATE "  
            + "     [<Owner>].[<Table>] "
            + "SET "
            <If Loop>
               <IsNotIdentity>
            + "    <SF[,]>[<Field>] = @New<Field> "
            </If Loop>
            + "WHERE "
            <If Loop>
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow=[0]>
            + "     [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow<>[0]>
            + " AND [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow=[0]>
            + "     ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow<>[0]>
            + " AND ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
            </If Loop>
            + "";
        SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
        updateCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (new<OwnerU>_<TableU>Class.<FieldU>.HasValue == true) {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", new<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (new<OwnerU>_<TableU>Class.<FieldU> != null) {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", new<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNotNull>
        updateCommand.Parameters.AddWithValue("@New<FieldU>", new<OwnerU>_<TableU>Class.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNotNull>
        updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<OwnerU>_<TableU>Class.<FieldU>);
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (old<OwnerU>_<TableU>Class.<FieldU>.HasValue == true) {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (old<OwnerU>_<TableU>Class.<FieldU> != null) {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
        </If Loop>
        try
        {
            connection.Open();
            int count = updateCommand.ExecuteNonQuery();
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
    }

    public static bool Delete(<OwnerU>_<TableU>Class cls<OwnerU>_<TableU>)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string deleteStatement
            = "DELETE FROM "  
            + "     [<Owner>].[<Table>] "
            + "WHERE " 
            <If Loop>
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow=[0]>
            + "     [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow<>[0]>
            + " AND [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow=[0]>
            + "     ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow<>[0]>
            + " AND ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
            </If Loop>
            + "";
        SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
        deleteCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNotNull>
        deleteCommand.Parameters.AddWithValue("@Old<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (cls<OwnerU>_<TableU>.<FieldU>.HasValue == true) {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (cls<OwnerU>_<TableU>.<FieldU> != null) {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
        </If Loop>
        try
        {
            connection.Open();
            int count = deleteCommand.ExecuteNonQuery();
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
    }

}

